Pandas Profiling Report

Dataset statistics

Number of variables	37
Number of observations	109
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	15.2 KiB
Average record size in memory	143.2 B

Variable types

BOOL	24
NUM	11
DATE	1
CAT	1

Reproduction

Analysis started	2020-08-17 20:11:14.773675
Analysis finished	2020-08-17 20:12:13.192950
Duration	58.42 seconds
Version	pandas-profiling v2.8.0
Command line	`pandas_profiling --config_file config.yaml [YOUR_FILE.csv]`
Download configuration	config.yaml

Warnings

`# Drops` has constant value "1"	Constant
`Offer ID1` has constant value "4915"	Constant
`Remaining Budget` has constant value "0"	Constant
`Name_First Access Solid B` has constant value "1"	Constant
`Offer Name1_First Access Solid Black Visa Credit Card - Display - Lead Submit - W4 (e-mail)` has constant value "1"	Constant
`Operational Status1_Live` has constant value "1"	Constant
`Payout Type1_1st PAGE SUBMIT` has constant value "1"	Constant
`Opens` is highly correlated with `Delivered`	High correlation
`Delivered` is highly correlated with `Opens`	High correlation
`Data Provider (group)_Venice` is highly correlated with `Data Provider (group)_Irvine`	High correlation
`Data Provider (group)_Irvine` is highly correlated with `Data Provider (group)_Venice`	High correlation
`Delivered` has unique values	Unique
`eCPM` has 5 (4.6%) zeros	Zeros
`EPC` has 5 (4.6%) zeros	Zeros
`CLR` has 33 (30.3%) zeros	Zeros
`Revenue` has 5 (4.6%) zeros	Zeros

Affiliate ID1
Real number (ℝ_≥0)

Distinct count	34
Unique (%)	31.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	460599.7706422018
Minimum	460121
Maximum	460828
Zeros	0
Zeros (%)	0.0%
Memory size	872.0 B

Quantile statistics

Minimum	460121
5-th percentile	460351
Q1	460454
median	460628
Q3	460744
95-th percentile	460809
Maximum	460828
Range	707
Interquartile range (IQR)	290

Descriptive statistics

Standard deviation	163.4923621
Coefficient of variation (CV)	0.0003549553702
Kurtosis	-0.5038418059
Mean	460599.7706
Median Absolute Deviation (MAD)	145
Skewness	-0.4711826948
Sum	50205375
Variance	26729.75246

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
460809	8	7.3%
460639	7	6.4%
460804	6	5.5%
460467	6	5.5%
460587	5	4.6%
460628	5	4.6%
460451	5	4.6%
460661	5	4.6%
460398	5	4.6%
460443	4	3.7%
Other values (24)	53	48.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
460121	1	0.9%
460218	2	1.8%
460297	1	0.9%
460351	3	2.8%
460379	4	3.7%

Value	Count	Frequency (%)
460828	4	3.7%
460809	8	7.3%
460804	6	5.5%
460767	4	3.7%
460766	1	0.9%

eCPM
Real number (ℝ_≥0)

ZEROS

Distinct count	96
Unique (%)	88.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	4.150550458715596
Minimum	0.0
Maximum	21.9
Zeros	5
Zeros (%)	4.6%
Memory size	872.0 B

Quantile statistics

Minimum	0
5-th percentile	0.236
Q1	1.62
median	3.74
Q3	5.54
95-th percentile	11.006
Maximum	21.9
Range	21.9
Interquartile range (IQR)	3.92

Descriptive statistics

Standard deviation	3.496684365
Coefficient of variation (CV)	0.8424628009
Kurtosis	5.318753487
Mean	4.150550459
Median Absolute Deviation (MAD)	1.99
Skewness	1.769663976
Sum	452.41
Variance	12.22680155

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0	5	4.6%
3.82	3	2.8%
1.17	3	2.8%
1.18	2	1.8%
4.23	2	1.8%
1.98	2	1.8%
2.29	2	1.8%
1.56	2	1.8%
6.95	1	0.9%
1.64	1	0.9%
Other values (86)	86	78.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	5	4.6%
0.22	1	0.9%
0.26	1	0.9%
0.34	1	0.9%
0.4	1	0.9%

Value	Count	Frequency (%)
21.9	1	0.9%
12.58	1	0.9%
12.01	1	0.9%
11.76	1	0.9%
11.41	1	0.9%

CTR
Real number (ℝ_≥0)

Distinct count	93
Unique (%)	85.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.014433944954128438
Minimum	0.001
Maximum	0.0534
Zeros	0
Zeros (%)	0.0%
Memory size	872.0 B

Quantile statistics

Minimum	0.001
5-th percentile	0.00272
Q1	0.0082
median	0.0128
Q3	0.0185
95-th percentile	0.03044
Maximum	0.0534
Range	0.0524
Interquartile range (IQR)	0.0103

Descriptive statistics

Standard deviation	0.009292771187
Coefficient of variation (CV)	0.6438136779
Kurtosis	3.291188583
Mean	0.01443394495
Median Absolute Deviation (MAD)	0.0052
Skewness	1.474736473
Sum	1.5733
Variance	8.635559633e-05

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0.0108	4	3.7%
0.0089	3	2.8%
0.0232	2	1.8%
0.0086	2	1.8%
0.0097	2	1.8%
0.0135	2	1.8%
0.013	2	1.8%
0.0122	2	1.8%
0.0067	2	1.8%
0.0147	2	1.8%
Other values (83)	86	78.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.001	1	0.9%
0.0011	1	0.9%
0.0015	1	0.9%
0.0017	1	0.9%
0.002	1	0.9%

Value	Count	Frequency (%)
0.0534	1	0.9%
0.0456	1	0.9%
0.0413	1	0.9%
0.0394	1	0.9%
0.0329	1	0.9%

EPC
Real number (ℝ_≥0)

ZEROS

Distinct count	47
Unique (%)	43.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.27844036697247704
Minimum	0.0
Maximum	0.66
Zeros	5
Zeros (%)	4.6%
Memory size	872.0 B

Quantile statistics

Minimum	0
5-th percentile	0.052
Q1	0.2
median	0.26
Q3	0.36
95-th percentile	0.52
Maximum	0.66
Range	0.66
Interquartile range (IQR)	0.16

Descriptive statistics

Standard deviation	0.1421017783
Coefficient of variation (CV)	0.5103490555
Kurtosis	0.1462308067
Mean	0.278440367
Median Absolute Deviation (MAD)	0.09
Skewness	0.3599414382
Sum	30.35
Variance	0.02019291539

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0.21	7	6.4%
0.32	6	5.5%
0.23	6	5.5%
0.41	5	4.6%
0.24	5	4.6%
0	5	4.6%
0.2	4	3.7%
0.14	4	3.7%
0.47	4	3.7%
0.28	4	3.7%
Other values (37)	59	54.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	5	4.6%
0.04	1	0.9%
0.07	1	0.9%
0.08	1	0.9%
0.09	1	0.9%

Value	Count	Frequency (%)
0.66	1	0.9%
0.65	1	0.9%
0.64	1	0.9%
0.57	1	0.9%
0.53	1	0.9%

CLR
Real number (ℝ_≥0)

ZEROS

Distinct count	54
Unique (%)	49.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.006869724770642201
Minimum	0.0
Maximum	0.0856
Zeros	33
Zeros (%)	30.3%
Memory size	872.0 B

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0.0031
Q3	0.0064
95-th percentile	0.0157
Maximum	0.0856
Range	0.0856
Interquartile range (IQR)	0.0064

Descriptive statistics

Standard deviation	0.01495860649
Coefficient of variation (CV)	2.177468093
Kurtosis	17.61872601
Mean	0.006869724771
Median Absolute Deviation (MAD)	0.0031
Skewness	4.191017426
Sum	0.7488
Variance	0.0002237599083

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0	33	30.3%
0.0025	4	3.7%
0.0019	3	2.8%
0.0117	3	2.8%
0.0053	3	2.8%
0.0056	3	2.8%
0.0031	2	1.8%
0.0033	2	1.8%
0.0064	2	1.8%
0.0063	2	1.8%
Other values (44)	52	47.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	33	30.3%
0.0006	1	0.9%
0.0014	1	0.9%
0.0015	1	0.9%
0.0016	2	1.8%

Value	Count	Frequency (%)
0.0856	1	0.9%
0.0818	1	0.9%
0.0756	1	0.9%
0.0589	1	0.9%
0.0568	1	0.9%

# Drops
Boolean

CONSTANT
REJECTED

Distinct count	1
Unique (%)	0.9%
Missing	0
Missing (%)	0.0%
Memory size	872.0 B

1	109

Frequency Table

Value	Count	Frequency (%)
1	109	100.0%

Click Rate
Real number (ℝ_≥0)

Distinct count	92
Unique (%)	84.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.10691467889908259
Minimum	0.027
Maximum	0.281
Zeros	0
Zeros (%)	0.0%
Memory size	872.0 B

Quantile statistics

Minimum	0.027
5-th percentile	0.04504
Q1	0.0801
median	0.1012
Q3	0.1278
95-th percentile	0.1908
Maximum	0.281
Range	0.254
Interquartile range (IQR)	0.0477

Descriptive statistics

Standard deviation	0.04607362631
Coefficient of variation (CV)	0.4309382658
Kurtosis	2.01640169
Mean	0.1069146789
Median Absolute Deviation (MAD)	0.0248
Skewness	1.150918925
Sum	11.6537
Variance	0.002122779042

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0.109	3	2.8%
0.095	3	2.8%
0.087	3	2.8%
0.067	2	1.8%
0.111	2	1.8%
0.075	2	1.8%
0.082	2	1.8%
0.084	2	1.8%
0.121	2	1.8%
0.108	2	1.8%
Other values (82)	86	78.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.027	1	0.9%
0.028	1	0.9%
0.043	1	0.9%
0.044	1	0.9%
0.045	2	1.8%

Value	Count	Frequency (%)
0.281	1	0.9%
0.247	1	0.9%
0.234	1	0.9%
0.223	1	0.9%
0.2121	1	0.9%

Clicks
Real number (ℝ_≥0)

Distinct count	105
Unique (%)	96.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	597.5045871559633
Minimum	42
Maximum	3621
Zeros	0
Zeros (%)	0.0%
Memory size	872.0 B

Quantile statistics

Minimum	42
5-th percentile	116
Q1	283
median	476
Q3	759
95-th percentile	1570
Maximum	3621
Range	3579
Interquartile range (IQR)	476

Descriptive statistics

Standard deviation	505.6823154
Coefficient of variation (CV)	0.8463237376
Kurtosis	11.48771409
Mean	597.5045872
Median Absolute Deviation (MAD)	225
Skewness	2.667603589
Sum	65128
Variance	255714.6041

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
183	2	1.8%
527	2	1.8%
730	2	1.8%
206	2	1.8%
1019	1	0.9%
847	1	0.9%
293	1	0.9%
566	1	0.9%
827	1	0.9%
319	1	0.9%
Other values (95)	95	87.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
42	1	0.9%
74	1	0.9%
83	1	0.9%
108	1	0.9%
109	1	0.9%

Value	Count	Frequency (%)
3621	1	0.9%
1971	1	0.9%
1836	1	0.9%
1827	1	0.9%
1721	1	0.9%

Date1
Date

Distinct count	52
Unique (%)	47.7%
Missing	0
Missing (%)	0.0%
Memory size	872.0 B

Minimum	2020-01-31 00:00:00
Maximum	2020-04-12 00:00:00

Histogram

Histogram

Delivered
Real number (ℝ_≥0)

HIGH CORRELATION
UNIQUE

Distinct count	109
Unique (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	52829.5871559633
Minimum	6812
Maximum	688381
Zeros	0
Zeros (%)	0.0%
Memory size	872.0 B

Quantile statistics

Minimum	6812
5-th percentile	14246.6
Q1	26151
median	38125
Q3	60720
95-th percentile	150529.4
Maximum	688381
Range	681569
Interquartile range (IQR)	34569

Descriptive statistics

Standard deviation	69998.11759
Coefficient of variation (CV)	1.324979455
Kurtosis	63.72661776
Mean	52829.58716
Median Absolute Deviation (MAD)	16312
Skewness	7.20160629
Sum	5758425
Variance	4899736466

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
688381	1	0.9%
42171	1	0.9%
7848	1	0.9%
20287	1	0.9%
29511	1	0.9%
47178	1	0.9%
155453	1	0.9%
14157	1	0.9%
34639	1	0.9%
68432	1	0.9%
Other values (99)	99	90.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
6812	1	0.9%
6864	1	0.9%
7401	1	0.9%
7848	1	0.9%
13970	1	0.9%

Value	Count	Frequency (%)
688381	1	0.9%
157408	1	0.9%
155453	1	0.9%
152206	1	0.9%
152147	1	0.9%

Offer ID1
Categorical

CONSTANT
REJECTED

Distinct count	1
Unique (%)	0.9%
Missing	0
Missing (%)	0.0%
Memory size	872.0 B

4915	109

Common Values
Length

Value	Count	Frequency (%)
4915	109	100.0%

Length

Max length	4
Median length	4
Mean length	4
Min length	4

Open Rate
Real number (ℝ_≥0)

Distinct count	94
Unique (%)	86.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.14038073394495412
Minimum	0.005
Maximum	0.342
Zeros	0
Zeros (%)	0.0%
Memory size	872.0 B

Quantile statistics

Minimum	0.005
5-th percentile	0.03296
Q1	0.1019
median	0.135
Q3	0.171
95-th percentile	0.27524
Maximum	0.342
Range	0.337
Interquartile range (IQR)	0.0691

Descriptive statistics

Standard deviation	0.06770971739
Coefficient of variation (CV)	0.4823291308
Kurtosis	1.090895719
Mean	0.1403807339
Median Absolute Deviation (MAD)	0.034
Skewness	0.7135547855
Sum	15.3015
Variance	0.004584605829

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0.09	3	2.8%
0.131	3	2.8%
0.143	2	1.8%
0.153	2	1.8%
0.161	2	1.8%
0.219	2	1.8%
0.185	2	1.8%
0.164	2	1.8%
0.101	2	1.8%
0.085	2	1.8%
Other values (84)	87	79.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.005	1	0.9%
0.007	2	1.8%
0.014	1	0.9%
0.015	1	0.9%
0.0326	1	0.9%

Value	Count	Frequency (%)
0.342	1	0.9%
0.327	1	0.9%
0.322	1	0.9%
0.313	1	0.9%
0.286	1	0.9%

Opens
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct count	108
Unique (%)	99.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	7157.8899082568805
Minimum	631
Maximum	130167
Zeros	0
Zeros (%)	0.0%
Memory size	872.0 B

Quantile statistics

Minimum	631
5-th percentile	888.4
Q1	2645
median	4719
Q3	7604
95-th percentile	18330.2
Maximum	130167
Range	129536
Interquartile range (IQR)	4959

Descriptive statistics

Standard deviation	12827.57427
Coefficient of variation (CV)	1.79208879
Kurtosis	79.76369562
Mean	7157.889908
Median Absolute Deviation (MAD)	2261
Skewness	8.360274
Sum	780210
Variance	164546661.6

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
2310	2	1.8%
7934	1	0.9%
5807	1	0.9%
19175	1	0.9%
5455	1	0.9%
4689	1	0.9%
2130	1	0.9%
21588	1	0.9%
2645	1	0.9%
3670	1	0.9%
Other values (98)	98	89.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
631	1	0.9%
713	1	0.9%
731	1	0.9%
741	1	0.9%
830	1	0.9%

Value	Count	Frequency (%)
130167	1	0.9%
21588	1	0.9%
21186	1	0.9%
19693	1	0.9%
19429	1	0.9%

Remaining Budget
Boolean

CONSTANT
REJECTED

Distinct count	1
Unique (%)	0.9%
Missing	0
Missing (%)	0.0%
Memory size	872.0 B

0	109

Frequency Table

Value	Count	Frequency (%)
0	109	100.0%

Revenue
Real number (ℝ_≥0)

ZEROS

Distinct count	29
Unique (%)	26.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	169.6880733944954
Minimum	0
Maximum	935
Zeros	5
Zeros (%)	4.6%
Memory size	872.0 B

Quantile statistics

Minimum	0
5-th percentile	17
Q1	68
median	119
Q3	204
95-th percentile	506.6
Maximum	935
Range	935
Interquartile range (IQR)	136

Descriptive statistics

Standard deviation	171.2543429
Coefficient of variation (CV)	1.009230286
Kurtosis	6.502105285
Mean	169.6880734
Median Absolute Deviation (MAD)	68
Skewness	2.355060711
Sum	18496
Variance	29328.04995

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
102	13	11.9%
85	12	11.0%
34	8	7.3%
170	7	6.4%
51	6	5.5%
187	5	4.6%
17	5	4.6%
153	5	4.6%
68	5	4.6%
0	5	4.6%
Other values (19)	38	34.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	5	4.6%
17	5	4.6%
34	8	7.3%
51	6	5.5%
68	5	4.6%

Value	Count	Frequency (%)
935	1	0.9%
816	1	0.9%
765	1	0.9%
748	1	0.9%
612	1	0.9%

Name_First Access Solid B
Boolean

CONSTANT
REJECTED

Distinct count	1
Unique (%)	0.9%
Missing	0
Missing (%)	0.0%
Memory size	109.0 B

1	109

Frequency Table

Value	Count	Frequency (%)
1	109	100.0%

Data Provider (group)_Irvine
Boolean

HIGH CORRELATION

Distinct count	2
Unique (%)	1.8%
Missing	0
Missing (%)	0.0%
Memory size	109.0 B

0	97
1	12

Frequency Table

Value	Count	Frequency (%)
0	97	89.0%
1	12	11.0%

Data Provider (group)_Venice
Boolean

HIGH CORRELATION

Distinct count	2
Unique (%)	1.8%
Missing	0
Missing (%)	0.0%
Memory size	109.0 B

1	97
0	12

Frequency Table

Value	Count	Frequency (%)
1	97	89.0%
0	12	11.0%

Data Vertical_Auto Loan
Boolean

Distinct count	2
Unique (%)	1.8%
Missing	0
Missing (%)	0.0%
Memory size	109.0 B

0	108
1	1

Frequency Table

Value	Count	Frequency (%)
0	108	99.1%
1	1	0.9%

Data Vertical_Credit
Boolean

Distinct count	2
Unique (%)	1.8%
Missing	0
Missing (%)	0.0%
Memory size	109.0 B

0	70
1	39

Frequency Table

Value	Count	Frequency (%)
0	70	64.2%
1	39	35.8%

Data Vertical_FHA
Boolean

Distinct count	2
Unique (%)	1.8%
Missing	0
Missing (%)	0.0%
Memory size	109.0 B

0	102
1	7

Frequency Table

Value	Count	Frequency (%)
0	102	93.6%
1	7	6.4%

Data Vertical_Grants
Boolean

Distinct count	2
Unique (%)	1.8%
Missing	0
Missing (%)	0.0%
Memory size	109.0 B

0	106
1	3

Frequency Table

Value	Count	Frequency (%)
0	106	97.2%
1	3	2.8%

Data Vertical_Internal
Boolean

Distinct count	2
Unique (%)	1.8%
Missing	0
Missing (%)	0.0%
Memory size	109.0 B

0	104
1	5

Frequency Table

Value	Count	Frequency (%)
0	104	95.4%
1	5	4.6%

Data Vertical_Paleo
Boolean

Distinct count	2
Unique (%)	1.8%
Missing	0
Missing (%)	0.0%
Memory size	109.0 B

0	108
1	1

Frequency Table

Value	Count	Frequency (%)
0	108	99.1%
1	1	0.9%

Data Vertical_Personal Loan
Boolean

Distinct count	2
Unique (%)	1.8%
Missing	0
Missing (%)	0.0%
Memory size	109.0 B

0	67
1	42

Frequency Table

Value	Count	Frequency (%)
0	67	61.5%
1	42	38.5%

Data Vertical_Refinance
Boolean

Distinct count	2
Unique (%)	1.8%
Missing	0
Missing (%)	0.0%
Memory size	109.0 B

0	107
1	2

Frequency Table

Value	Count	Frequency (%)
0	107	98.2%
1	2	1.8%

Data Vertical_Rent To Own
Boolean

Distinct count	2
Unique (%)	1.8%
Missing	0
Missing (%)	0.0%
Memory size	109.0 B

0	100
1	9

Frequency Table

Value	Count	Frequency (%)
0	100	91.7%
1	9	8.3%

Offer Name1_First Access Solid Black Visa Credit Card - Display - Lead Submit - W4 (e-mail)
Boolean

CONSTANT
REJECTED

Distinct count	1
Unique (%)	0.9%
Missing	0
Missing (%)	0.0%
Memory size	109.0 B

1	109

Frequency Table

Value	Count	Frequency (%)
1	109	100.0%

Operational Status1_Live
Boolean

CONSTANT
REJECTED

Distinct count	1
Unique (%)	0.9%
Missing	0
Missing (%)	0.0%
Memory size	109.0 B

1	109

Frequency Table

Value	Count	Frequency (%)
1	109	100.0%

Payout Type1_1st PAGE SUBMIT
Boolean

CONSTANT
REJECTED

Distinct count	1
Unique (%)	0.9%
Missing	0
Missing (%)	0.0%
Memory size	109.0 B

1	109

Frequency Table

Value	Count	Frequency (%)
1	109	100.0%

Segment1_A14
Boolean

Distinct count	2
Unique (%)	1.8%
Missing	0
Missing (%)	0.0%
Memory size	109.0 B

0	108
1	1

Frequency Table

Value	Count	Frequency (%)
0	108	99.1%
1	1	0.9%

Segment1_A21
Boolean

Distinct count	2
Unique (%)	1.8%
Missing	0
Missing (%)	0.0%
Memory size	109.0 B

0	106
1	3

Frequency Table

Value	Count	Frequency (%)
0	106	97.2%
1	3	2.8%

Segment1_MI
Boolean

Distinct count	2
Unique (%)	1.8%
Missing	0
Missing (%)	0.0%
Memory size	109.0 B

0	103
1	6

Frequency Table

Value	Count	Frequency (%)
0	103	94.5%
1	6	5.5%

Segment1_O1
Boolean

Distinct count	2
Unique (%)	1.8%
Missing	0
Missing (%)	0.0%
Memory size	109.0 B

0	107
1	2

Frequency Table

Value	Count	Frequency (%)
0	107	98.2%
1	2	1.8%

Segment1_O14
Boolean

Distinct count	2
Unique (%)	1.8%
Missing	0
Missing (%)	0.0%
Memory size	109.0 B

0	101
1	8

Frequency Table

Value	Count	Frequency (%)
0	101	92.7%
1	8	7.3%

Segment1_O21
Boolean

Distinct count	2
Unique (%)	1.8%
Missing	0
Missing (%)	0.0%
Memory size	109.0 B

0	94
1	15

Frequency Table

Value	Count	Frequency (%)
0	94	86.2%
1	15	13.8%

Segment1_O30
Boolean

Distinct count	2
Unique (%)	1.8%
Missing	0
Missing (%)	0.0%
Memory size	109.0 B

1	74
0	35

Frequency Table

Value	Count	Frequency (%)
1	74	67.9%
0	35	32.1%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Count
Matrix

First rows

	Affiliate ID1	eCPM	CTR	EPC	# Drops	Click Rate	Clicks	Date1	Delivered	Offer ID1	Open Rate	Opens	Revenue	Name_First Access Solid B	Data Provider (group)_Venice	Data Vertical_Credit	Data Vertical_Personal Loan	Offer Name1_First Access Solid Black Visa Credit Card - Display - Lead Submit - W4 (e-mail)	Operational Status1_Live	Payout Type1_1st PAGE SUBMIT	Segment1_O1	Segment1_O14	Segment1_O21	Segment1_O30
0	460639	5.48	0.0193	0.28	1	0.1042	777	2020-03-02	40318	4915	0.185	7458	221	1	1	1	0	1	1	1	0	0	0	1
1	460804	4.02	0.0196	0.21	1	0.1210	1240	2020-04-09	63419	4915	0.161	10231	255	1	1	0	1	1	1	1	0	1	0	0
2	460639	11.41	0.0413	0.28	1	0.1260	615	2020-03-13	14899	4915	0.327	4874	170	1	1	1	0	1	1	1	1	0	0	0
3	460639	8.23	0.0456	0.18	1	0.1460	659	2020-03-27	14451	4915	0.313	4518	119	1	1	1	0	1	1	1	1	0	0	0
4	460804	12.58	0.0265	0.47	1	0.1210	1971	2020-03-22	74337	4915	0.219	16314	935	1	1	0	1	1	1	1	0	0	1	0
5	460804	11.76	0.0263	0.45	1	0.1630	1827	2020-03-12	69408	4915	0.161	11185	816	1	1	0	1	1	1	1	0	0	1	0
6	460467	11.25	0.0240	0.47	1	0.0840	1630	2020-03-10	67988	4915	0.286	19429	765	1	1	0	1	1	1	1	0	1	0	0
7	460467	1.56	0.0067	0.23	1	0.0570	363	2020-03-20	54576	4915	0.117	6393	85	1	1	0	1	1	1	1	0	1	0	0
8	460467	2.24	0.0067	0.33	1	0.0660	408	2020-04-09	60720	4915	0.101	6157	136	1	1	0	1	1	1	1	0	1	0	0
9	460639	3.73	0.0160	0.23	1	0.1050	730	2020-04-08	45622	4915	0.153	6980	170	1	1	1	0	1	1	1	0	0	0	1

Last rows

	Affiliate ID1	eCPM	CTR	EPC	CLR	# Drops	Click Rate	Clicks	Date1	Delivered	Offer ID1	Open Rate	Opens	Revenue	Name_First Access Solid B	Data Provider (group)_Venice	Data Vertical_Credit	Data Vertical_FHA	Data Vertical_Personal Loan	Data Vertical_Rent To Own	Offer Name1_First Access Solid Black Visa Credit Card - Display - Lead Submit - W4 (e-mail)	Operational Status1_Live	Payout Type1_1st PAGE SUBMIT	Segment1_O14	Segment1_O30
99	460750	2.68	0.0112	0.24	0.0033	1	0.0860	497	2020-04-01	44347	4915	0.1310	5807	119	1	1	0	0	0	1	1	1	1	0	1
100	460351	10.48	0.0314	0.33	0.0016	1	0.1146	1325	2020-02-11	42171	4915	0.2741	11557	442	1	1	1	0	0	0	1	1	1	0	1
101	460351	5.35	0.0169	0.32	0.0006	1	0.0801	646	2020-02-23	38125	4915	0.2116	8069	204	1	1	1	0	0	0	1	1	1	0	1
102	460483	2.06	0.0089	0.23	0.0000	1	0.0559	294	2020-02-27	33070	4915	0.1591	5262	68	1	1	0	1	0	0	1	1	1	0	1
103	460639	0.40	0.0107	0.04	0.0000	1	0.1312	458	2020-02-03	42956	4915	0.0812	3490	17	1	1	1	0	0	0	1	1	1	0	1
104	460724	3.82	0.0108	0.35	0.0000	1	0.0798	289	2020-02-07	26722	4915	0.1355	3622	102	1	1	0	0	0	1	1	1	1	0	1
105	460724	1.17	0.0129	0.09	0.0000	1	0.0814	374	2020-02-29	28976	4915	0.1586	4595	34	1	1	0	0	0	1	1	1	1	0	1
106	460743	7.52	0.0115	0.66	0.0000	1	0.0830	389	2020-02-23	33905	4915	0.1383	4689	255	1	1	0	0	1	0	1	1	1	1	0
107	460743	4.54	0.0141	0.32	0.0000	1	0.0818	476	2020-02-29	33672	4915	0.1727	5816	153	1	1	0	0	1	0	1	1	1	1	0
108	460743	9.46	0.0232	0.41	0.0000	1	0.1292	875	2020-02-16	37733	4915	0.1794	6771	357	1	1	0	0	1	0	1	1	1	0	1

Overview

Variables

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Missing values

Sample

First rows

Last rows